USE EMODE
	
-- Drop foreign keys --


	
-- Tables Emode --

Go
IF OBJECT_ID('PROMOTION_LOOKUP', 'U') IS NOT NULL
	DROP TABLE [dbo].[PROMOTION_LOOKUP];

Go
IF OBJECT_ID('CALENDAR_YEAR_LOOKUP', 'U') IS NOT NULL
	DROP TABLE [dbo].[CALENDAR_YEAR_LOOKUP]

Go
IF OBJECT_ID('ARTICLE_LOOKUP', 'U') IS NOT NULL
	DROP TABLE [dbo].[ARTICLE_LOOKUP]

Go	
IF OBJECT_ID('PRODUCT_PROMOTION_FACTS', 'U') IS NOT NULL
	DROP TABLE [dbo].[PRODUCT_PROMOTION_FACTS]

Go
IF OBJECT_ID('ARTICLE_LOOKUP_CRITERIA', 'U') IS NOT NULL
	DROP TABLE [dbo].[ARTICLE_LOOKUP_CRITERIA]

Go
IF OBJECT_ID('OUTLET_LOOKUP', 'U') IS NOT NULL
	DROP TABLE [dbo].[OUTLET_LOOKUP]
	
Go
IF OBJECT_ID('ARTICLE_COLOR_LOOKUP', 'U') IS NOT NULL
	DROP TABLE [dbo].[ARTICLE_COLOR_LOOKUP]

Go
IF OBJECT_ID('SHOP_FACTS', 'U') IS NOT NULL
	DROP TABLE [dbo].[SHOP_FACTS]
	
-- Tables de rejet --

Go
IF OBJECT_ID('SHOP_FACTS_REJ', 'U') IS NOT NULL
	DROP TABLE [dbo].[SHOP_FACTS_REJ]

Go
IF OBJECT_ID('ARTICLE_COLOR_LOOKUP_REJ', 'U') IS NOT NULL
	DROP TABLE [dbo].[ARTICLE_COLOR_LOOKUP_REJ]

Go
IF OBJECT_ID('ARTICLE_LOOKUP_REJ', 'U') IS NOT NULL
	DROP TABLE [dbo].[ARTICLE_LOOKUP_REJ]

Go
IF OBJECT_ID('OUTLET_LOOKUP_REJ', 'U') IS NOT NULL
	DROP TABLE [dbo].[OUTLET_LOOKUP_REJ]

Go
IF OBJECT_ID('CALENDAR_YEAR_LOOKUP_REJ', 'U') IS NOT NULL
	DROP TABLE [dbo].[CALENDAR_YEAR_LOOKUP_REJ]

Go
IF OBJECT_ID('PRODUCT_PROMOTION_FACTS_REJ', 'U') IS NOT NULL
	DROP TABLE [dbo].[PRODUCT_PROMOTION_FACTS_REJ]

Go
IF OBJECT_ID('PROMOTION_LOOKUP_REJ', 'U') IS NOT NULL
	DROP TABLE [dbo].[PROMOTION_LOOKUP_REJ]

Go
IF OBJECT_ID('ARTICLE_LOOKUP_CRITERIA_REJ', 'U') IS NOT NULL
	DROP TABLE [dbo].[ARTICLE_LOOKUP_CRITERIA_REJ]